--@author Tran Minh Vuong - 0934103448 - tmvuong89@gmail.com
--27.04.2012

CREATE PROC CustomersInsert
@CustomersID nvarchar(15),
@CustomersName nvarchar(50),
@CustomersBirthday date,
@CustomersPhone nvarchar(13),
@CustomersEmail nvarchar(50),
@CustomersAddress nvarchar(MAX)
AS
BEGIN
INSERT INTO Customers (
						CustomersID,
						CustomersName,
						CustomersBirthday,
						CustomersPhone,
						CustomersEmail,
						CustomersAddress
						)
						VALUES
						(
						@CustomersID,
						@CustomersName,
						@CustomersBirthday,
						@CustomersPhone,
						@CustomersEmail,
						@CustomersAddress
						)
END
GO
--
ALTER PROC CustomersGetAll
AS
BEGIN
SELECT 
		CustomersID AS ID,
		CustomersName AS Name,
		CustomersBirthday AS Birthday,
		CustomersPhone AS Phone,
		CustomersEmail AS Email,
		CustomersAddress AS Address 
FROM Customers
END
GO

--==
